/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.2.100
 Source Server Type    : MySQL
 Source Server Version : 50635
 Source Host           : 192.168.2.100:3306
 Source Schema         : fk_test

 Target Server Type    : MySQL
 Target Server Version : 50635
 File Encoding         : 65001

 Date: 22/07/2020 11:09:33
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for es_bill_member
-- ----------------------------
DROP TABLE IF EXISTS `es_bill_member`;
CREATE TABLE `es_bill_member` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `total_id` bigint(20) DEFAULT NULL COMMENT '总结算单id',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员id',
  `start_time` int(10) DEFAULT NULL COMMENT '开始时间',
  `end_time` int(10) DEFAULT NULL COMMENT '结束时间',
  `final_money` decimal(10,2) DEFAULT NULL COMMENT '最终结算金额',
  `push_money` decimal(10,2) DEFAULT NULL COMMENT '提成金额',
  `order_money` decimal(10,2) DEFAULT NULL COMMENT '订单金额',
  `return_order_money` decimal(10,2) DEFAULT NULL COMMENT '订单返还金额',
  `return_push_money` decimal(10,2) DEFAULT NULL COMMENT '返还提成金额',
  `member_name` varchar(255) DEFAULT NULL COMMENT '会员名称',
  `sn` varchar(255) DEFAULT NULL COMMENT '编号',
  `order_count` int(10) DEFAULT NULL COMMENT '订单数',
  `return_order_count` int(10) DEFAULT NULL COMMENT '返还订单数',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_bill_member` (`id`,`member_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='个人业绩单(es_bill_member)';

-- ----------------------------
-- Records of es_bill_member
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_bill_total
-- ----------------------------
DROP TABLE IF EXISTS `es_bill_total`;
CREATE TABLE `es_bill_total` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `start_time` bigint(12) DEFAULT NULL COMMENT '开始时间',
  `end_time` bigint(12) DEFAULT NULL COMMENT '结束时间',
  `order_count` bigint(12) DEFAULT NULL COMMENT '订单数量',
  `return_order_count` int(10) DEFAULT NULL COMMENT '退还订单数量',
  `final_money` decimal(20,2) DEFAULT NULL COMMENT '结算金额',
  `push_money` decimal(20,2) DEFAULT NULL COMMENT '提成金额',
  `return_push_money` decimal(20,2) DEFAULT NULL COMMENT '退还提成金额',
  `order_money` decimal(20,2) DEFAULT NULL COMMENT '订单金额',
  `return_order_money` decimal(20,2) DEFAULT NULL COMMENT '退还订单金额',
  `sn` varchar(255) DEFAULT NULL COMMENT '编号',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_bill_total` (`id`,`sn`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='总业绩单(es_bill_total)';

-- ----------------------------
-- Records of es_bill_total
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_commission_tpl
-- ----------------------------
DROP TABLE IF EXISTS `es_commission_tpl`;
CREATE TABLE `es_commission_tpl` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `tpl_name` varchar(20) DEFAULT NULL COMMENT '名称',
  `tpl_describe` varchar(255) DEFAULT NULL COMMENT '描述',
  `cycle` int(10) DEFAULT NULL COMMENT '周期',
  `grade1` decimal(10,2) DEFAULT NULL COMMENT '1级返利',
  `grade2` decimal(10,2) DEFAULT NULL COMMENT '2级返利',
  `is_default` smallint(1) DEFAULT NULL COMMENT '是否默认',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_commission_tpl` (`id`,`cycle`,`grade1`,`grade2`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='模版(es_commission_tpl)';

-- ----------------------------
-- Records of es_commission_tpl
-- ----------------------------
BEGIN;
INSERT INTO `es_commission_tpl` VALUES (1, '小伙伴', '提成模板', 30, 1.00, 2.00, 1);
INSERT INTO `es_commission_tpl` VALUES (2, '合伙人', '提成模板', 200, 2.00, 3.00, 0);
COMMIT;

-- ----------------------------
-- Table structure for es_distribution
-- ----------------------------
DROP TABLE IF EXISTS `es_distribution`;
CREATE TABLE `es_distribution` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员id',
  `member_name` varchar(255) DEFAULT NULL COMMENT '会员名称',
  `path` varchar(255) DEFAULT NULL COMMENT '关系路径',
  `member_id_lv2` bigint(20) DEFAULT NULL COMMENT '上上级',
  `member_id_lv1` bigint(20) DEFAULT NULL COMMENT '上级',
  `downline` bigint(20) DEFAULT NULL COMMENT '下线人数',
  `order_num` bigint(20) DEFAULT NULL COMMENT '订单数',
  `rebate_total` decimal(20,2) DEFAULT NULL COMMENT '返利总额',
  `turnover_price` decimal(20,2) DEFAULT NULL COMMENT '营业额总额',
  `can_rebate` decimal(20,2) DEFAULT NULL COMMENT '可提现金额',
  `commission_frozen` decimal(20,2) DEFAULT NULL COMMENT '返利金额冻结',
  `current_tpl_name` varchar(255) DEFAULT NULL COMMENT '使用模版名称',
  `current_tpl_id` bigint(20) DEFAULT NULL COMMENT '使用模版',
  `withdraw_frozen_price` decimal(20,2) DEFAULT NULL COMMENT '提现冻结',
  `create_time` bigint(20) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_distribution` (`id`,`member_id`,`member_id_lv2`,`member_id_lv1`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='分销商(es_distribution)';

-- ----------------------------
-- Records of es_distribution
-- ----------------------------
BEGIN;
INSERT INTO `es_distribution` VALUES (1, 2, 'javashop', '0|2|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1421329021);
INSERT INTO `es_distribution` VALUES (2, 6, 'demo_woman', '0|6|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1427854864);
INSERT INTO `es_distribution` VALUES (3, 11, 'toys', '0|11|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1427962143);
INSERT INTO `es_distribution` VALUES (4, 16, 'food', '0|16|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1428651298);
INSERT INTO `es_distribution` VALUES (5, 25, 'superman', '0|25|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1464430868);
INSERT INTO `es_distribution` VALUES (6, 26, 'kans', '0|26|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1464509078);
INSERT INTO `es_distribution` VALUES (7, 27, 'appliance', '0|27|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1508506621);
INSERT INTO `es_distribution` VALUES (8, 28, 'kanon', '0|28|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509000654);
INSERT INTO `es_distribution` VALUES (9, 29, 'wanghui', '0|29|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509000745);
INSERT INTO `es_distribution` VALUES (10, 30, 'xulipeng', '0|30|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509000772);
INSERT INTO `es_distribution` VALUES (11, 31, 'spring', '0|31|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509009430);
INSERT INTO `es_distribution` VALUES (12, 32, 'martin', '0|32|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509009465);
INSERT INTO `es_distribution` VALUES (13, 33, 'java', '0|33|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509009516);
INSERT INTO `es_distribution` VALUES (14, 34, '六月的雨', '0|34|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509009562);
INSERT INTO `es_distribution` VALUES (15, 35, '陈冠希_', '0|35|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509009674);
INSERT INTO `es_distribution` VALUES (16, 36, '秋刀鱼的滋味', '0|36|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509009737);
INSERT INTO `es_distribution` VALUES (17, 37, '春风十里_不如你', '0|37|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509009786);
INSERT INTO `es_distribution` VALUES (18, 38, '下个路口见', '0|38|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509009923);
INSERT INTO `es_distribution` VALUES (19, 39, 'batman', '0|39|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509073225);
INSERT INTO `es_distribution` VALUES (20, 40, 'spiderman', '0|40|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509073858);
INSERT INTO `es_distribution` VALUES (21, 41, 'antman', '0|41|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509074080);
INSERT INTO `es_distribution` VALUES (22, 42, 'ironman', '0|42|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509074212);
INSERT INTO `es_distribution` VALUES (23, 43, 'hock', '0|43|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509074489);
INSERT INTO `es_distribution` VALUES (24, 44, 'eagle', '0|44|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509075137);
INSERT INTO `es_distribution` VALUES (25, 45, 'green', '0|45|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509075866);
INSERT INTO `es_distribution` VALUES (26, 46, 'blue', '0|46|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509084831);
INSERT INTO `es_distribution` VALUES (27, 47, 'black', '0|47|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509084961);
INSERT INTO `es_distribution` VALUES (28, 48, 'lion', '0|48|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509085091);
INSERT INTO `es_distribution` VALUES (29, 49, '麦芽糖_', '0|49|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509431392);
INSERT INTO `es_distribution` VALUES (30, 50, '回到过去', '0|50|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1509433744);
INSERT INTO `es_distribution` VALUES (31, 51, 'm_18555555555', '0|51|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1534837036);
INSERT INTO `es_distribution` VALUES (32, 52, 'fengkun', '0|52|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1534917930);
INSERT INTO `es_distribution` VALUES (33, 53, 'chopper', '0|53|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1535340715);
INSERT INTO `es_distribution` VALUES (34, 54, 'AAA', '0|54|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1535442162);
INSERT INTO `es_distribution` VALUES (35, 55, 'javashop7', '0|55|', 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, '小伙伴', 1, 0.00, 1535443163);
COMMIT;

-- ----------------------------
-- Table structure for es_distribution_goods
-- ----------------------------
DROP TABLE IF EXISTS `es_distribution_goods`;
CREATE TABLE `es_distribution_goods` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `goods_id` bigint(20) DEFAULT NULL COMMENT '商品id',
  `grade1_rebate` decimal(20,2) DEFAULT NULL COMMENT '一级返现',
  `grade2_rebate` decimal(20,2) DEFAULT NULL COMMENT '二级返现',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_distribution_goods` (`id`,`goods_id`,`grade1_rebate`,`grade2_rebate`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='分销商品返现(es_distribution_goods)';

-- ----------------------------
-- Records of es_distribution_goods
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_distribution_order
-- ----------------------------
DROP TABLE IF EXISTS `es_distribution_order`;
CREATE TABLE `es_distribution_order` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `order_id` bigint(20) DEFAULT NULL COMMENT '订单id',
  `order_sn` varchar(255) DEFAULT NULL COMMENT '订单sn',
  `buyer_member_id` bigint(20) DEFAULT NULL COMMENT '购买会员id',
  `buyer_member_name` varchar(255) DEFAULT NULL COMMENT '购买会员名称',
  `member_id_lv1` bigint(20) DEFAULT NULL COMMENT '一级分销商id',
  `member_id_lv2` bigint(20) DEFAULT NULL COMMENT '二级分销商id',
  `bill_id` bigint(20) DEFAULT NULL COMMENT '结算单id',
  `settle_cycle` bigint(20) DEFAULT NULL COMMENT '解冻日期',
  `create_time` bigint(20) DEFAULT NULL COMMENT '订单创建时间',
  `order_price` decimal(20,2) DEFAULT NULL COMMENT '订单金额',
  `grade1_rebate` decimal(20,2) DEFAULT NULL COMMENT '1级提成金额',
  `grade2_rebate` decimal(20,2) DEFAULT NULL COMMENT '2级提成金额',
  `grade1_sellback_price` decimal(20,2) DEFAULT NULL COMMENT '1级退款金额',
  `grade2_sellback_price` decimal(20,2) DEFAULT NULL COMMENT '2级退款金额',
  `is_return` smallint(1) DEFAULT NULL COMMENT '是否退货',
  `return_money` decimal(20,2) DEFAULT NULL COMMENT '退款金额',
  `is_withdraw` smallint(1) DEFAULT '0' COMMENT '是否已经提现',
  `seller_id` bigint(20) DEFAULT '1' COMMENT '店铺id',
  `seller_name` varchar(255) DEFAULT 'test' COMMENT '店铺名称',
  `lv1_point` decimal(10,2) DEFAULT NULL COMMENT '一级饭点比例',
  `lv2_point` decimal(10,2) DEFAULT NULL COMMENT '二级返点比例',
  `goods_rebate` longtext COMMENT '商品返现描述详细',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_distribution_order` (`id`,`order_id`,`order_sn`,`buyer_member_id`,`member_id_lv1`,`member_id_lv2`,`bill_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='分销订单(es_distribution_order)';

-- ----------------------------
-- Records of es_distribution_order
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_seller_bill
-- ----------------------------
DROP TABLE IF EXISTS `es_seller_bill`;
CREATE TABLE `es_seller_bill` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `seller_id` bigint(20) DEFAULT NULL COMMENT '商家id',
  `create_time` bigint(20) DEFAULT NULL COMMENT '创建时间',
  `order_sn` varchar(255) DEFAULT NULL COMMENT '订单编号',
  `expenditure` decimal(20,2) DEFAULT NULL COMMENT '商品反现支出',
  `return_expenditure` decimal(20,2) DEFAULT NULL COMMENT '返还商品反现支出',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_seller_bill` (`id`,`seller_id`,`order_sn`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='店铺结算(es_seller_bill)';

-- ----------------------------
-- Records of es_seller_bill
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_short_url
-- ----------------------------
DROP TABLE IF EXISTS `es_short_url`;
CREATE TABLE `es_short_url` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `url` varchar(255) DEFAULT NULL COMMENT '跳转地址',
  `su` varchar(255) DEFAULT NULL COMMENT '短链接key',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_short_url` (`id`,`url`,`su`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='短链接(es_short_url)';

-- ----------------------------
-- Records of es_short_url
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_upgrade_log
-- ----------------------------
DROP TABLE IF EXISTS `es_upgrade_log`;
CREATE TABLE `es_upgrade_log` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员id',
  `member_name` varchar(255) DEFAULT NULL COMMENT '会员名称',
  `type` varchar(255) DEFAULT NULL COMMENT '切换类型',
  `old_tpl_id` bigint(20) DEFAULT NULL COMMENT '旧的模板id',
  `new_tpl_id` bigint(20) DEFAULT NULL COMMENT '新的模板id',
  `new_tpl_name` varchar(255) DEFAULT NULL COMMENT '新的模板名称',
  `old_tpl_name` varchar(255) DEFAULT NULL COMMENT '旧的模板名称',
  `create_time` int(20) DEFAULT NULL COMMENT '创建日期',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_upgrade_log` (`id`,`member_id`,`old_tpl_id`,`new_tpl_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='升级日志(es_upgrade_log)';

-- ----------------------------
-- Records of es_upgrade_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_withdraw_apply
-- ----------------------------
DROP TABLE IF EXISTS `es_withdraw_apply`;
CREATE TABLE `es_withdraw_apply` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `apply_money` decimal(20,2) DEFAULT NULL COMMENT '提现金额',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员id',
  `member_name` varchar(255) DEFAULT NULL COMMENT '会员名称',
  `apply_remark` varchar(255) DEFAULT NULL COMMENT '申请备注',
  `inspect_remark` varchar(255) DEFAULT NULL COMMENT '审核备注',
  `transfer_remark` varchar(255) DEFAULT NULL COMMENT '转账备注',
  `apply_time` int(11) DEFAULT NULL COMMENT '申请时间',
  `inspect_time` int(11) DEFAULT NULL COMMENT '审核时间',
  `transfer_time` int(11) DEFAULT NULL COMMENT '转账时间',
  `status` varchar(255) DEFAULT NULL COMMENT '状态',
  `sn` varchar(255) DEFAULT NULL COMMENT '编号',
  `ip` varchar(255) DEFAULT NULL COMMENT 'ip地址',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_withdraw_apply` (`id`,`member_id`,`sn`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='提现申请(es_withdraw_apply)';

-- ----------------------------
-- Records of es_withdraw_apply
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_withdraw_setting
-- ----------------------------
DROP TABLE IF EXISTS `es_withdraw_setting`;
CREATE TABLE `es_withdraw_setting` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `member_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `param` varchar(255) DEFAULT NULL COMMENT '参数',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_withdraw_setting` (`id`,`member_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='分销提现设置(es_withdraw_setting)';

-- ----------------------------
-- Records of es_withdraw_setting
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for undo_log
-- ----------------------------
DROP TABLE IF EXISTS `undo_log`;
CREATE TABLE `undo_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'increment id',
  `branch_id` bigint(20) NOT NULL COMMENT 'branch transaction id',
  `xid` varchar(100) NOT NULL COMMENT 'global transaction id',
  `context` varchar(128) NOT NULL COMMENT 'undo_log context,such as serialization',
  `rollback_info` longblob NOT NULL COMMENT 'rollback info',
  `log_status` int(11) NOT NULL COMMENT '0:normal status,1:defense status',
  `log_created` datetime NOT NULL COMMENT 'create datetime',
  `log_modified` datetime NOT NULL COMMENT 'modify datetime',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3085 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='AT transaction mode undo table';

-- ----------------------------
-- Records of undo_log
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
